home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Magnum One
/
Magnum One (Mid-American Digital) (Disc Manufacturing).iso
/
d27
/
discus3x.arc
/
AS4BCH.THD
< prev
next >
Wrap
Text File
|
1991-12-04
|
4KB
|
59 lines
AS4BCH.THD
AS/400 - Running queries in batch queue.
Is there any way to run queries in batch as on the S/38? A member suggests one
way, involving predefined queries.
.
.This is an ASCII file. READ or DOWNLOAD with any supported protocol.
Upl: Anne E. Pruitt 72335,777
BATCH AS/400 IBM QUERY QUEUE
#: 29754 S5/Technical-Big Sys
22-May-90 12:37:21
Sb: AS/400 Query in Batch?
Fm: Tom Quinn 71101,3176
To: All
Here's a question for AS/400 gurus. When we used to use a S/38 we could
easily run our Queries in batch just by selecting a batch queue. The Query on
the AS/400 doesn't give the option and our MIS people say AS/400 Query cannot
be run in batch. We find this hard to believe. What's the scoop? Thanks.
#: 29809 S5/Technical-Big Sys
22-May-90 18:23:51
Sb: #29754-#AS/400 Query in Batch?
Fm: will cardwell 71560,1006
To: Tom Quinn 71101,3176 (X)
You can run query in batch. The problem is, you have to submit the RUNQRY
command and run a predefined query. There is no way to force a user to do
this or even to offer him the option if he uses the IBM supplied menus. The
typical user wants to define a query and then run it. When you allow the user
to do this, it will always be run interactively.
What I have done on my client's system is create a subsystem specifically for
query. When a user wants run run query, he selects an option off of one of my
menus. The CL program controlling the menu transfers the user to the query
subsystem by way of the TFRJOB command and calls another CL program to run
Query (STRQRY). The subsystem definition contains a routing entry and class
which cause the query job to run at a priority lower than normal interactive
work. The subsystem also has its own storage pool. Therefore, even though
the user is defining and running his queries interactively, there is minimal
impact on the other interactive users. When the query user is finished, a
"return" from query returns to the CL program in the query subsystem which
then does a TFRJOB back to QINTER.
#: 29834 S5/Technical-Big Sys
22-May-90 20:52:57
Sb: #29809-AS/400 Query in Batch?
Fm: Tom Quinn 71101,3176
To: will cardwell 71560,1006
Thanks for the info. Running at a lower priority would not help us. What we
need to do is free up the users from having to wait while their queries are
being run. It would be nice if they could submit several and go onto
something else. I find it curious that the batch option was dropped in the
AS/400.